You are here: 1. Distribution System > 1.10. MAINTENANCE Menu: System Maintenance > 1.10.14. Maintenance - Other Maintenance > 1.10.14.4. Maintenance - Other Maintenance - Change Suppliers > Changing a Batch of Supplier Numbers
Changing a Batch of Supplier Numbers

Supplier numbers (or creditor numbers for MCL) can be changed in a batch from a prepared file that contains the old supplier/creditor number and the new supplier/creditor number in a standard ASCII comma delimited form (a CSV file). This file would normally be created using a text editor or spreadsheet such as Excel. The expected format for the CSV file is as follows:

Old Supplier/Creditor Number, New Supplier/Creditor Number

To import the supplier numbers to be changed from a CSV file:

  1. Select MAINTENANCE | OTHER MAINTENANCE | CHANGE SUPPLIERS.

Micronet displays the Change Supplier Numbers screen.

  1. Select EDIT | FILE.

Micronet disables the individual supplier fields.

  1. Complete the following fields:

 

Field

Value

 

Save Old Supplier

Select whether you want to save the old supplier in the Supplier master file. Options are:

  • No - move the old supplier to the new supplier number (deleting the old supplier)
  • Yes - create a duplicate of the old supplier with the new supplier number (saving the old supplier)

 

Change History

Select whether you want the supplier number updated in the sales, purchase and account histories. Options are:

  • No - retain the history files with reference to the old supplier number
  • Yes - update your history files with the new supplier number. This effectively removes any trace of the old supplier number.

 

Change Creditors

Where Micronet Creditors Ledger is installed, suppliers and creditors are linked by a common number. If you are changing the supplier number, it would be normal to also change the creditor number.

Select whether you want the supplier number updated in your Creditors master file in MCL. Options are:

  • No – don't update the Creditors master file in MCL
  • Yes – update the Creditors master file in MCL with the new supplier number.
  1. Select FILE | START.

Micronet displays the standard Windows Open screen.

  1. Find and select the CSV file containing your changes to supplier numbers and select Open.

Micronet processes the requested supplier change, creating an output file of the same name as your CSV file but with a .err extension. This output file contains all errors along with the process date and time stamp.

 

Warning

Once started, do not try to stop the process under any circumstances.